A campaign that was really well executed was the Heroes of Might and Magic 3 Campaign with Sandro. Baiting heroes into collecting artifacts needed to form the Armor of the Damned and the Cloak of the Undead King is one thing. Getting to play with it is another. Raising legions of liches and power liches just can't be compared.
One of the best gaming experiences by far.
Link to timelapse: https://youtube.com/shorts/cW1tE7r-tDU